Avoid acquiring lock if no pending migrations

[mfridman]

Picking up from https://github.com/pressly/goose/pull/507#discussion_r1266498077.

This might be a good idea, although need to think carefully about how to implement this.