WithLock is equivalent to WithLockOpts() with opts == nil.

WithLockOpts try to get/hold a MySQL lock (GET_LOCK) and run a callback, until context done or connection lost.

LockNotAcquired is returned when lock is held by other already.

LockOptDefaultCooldownInterval is the default value of LockOptions.CooldownInterval.

LockOptDefaultLogger is the default value of LockOptions.Logger.

LockOptDefaultPingInterval is the default value of LockOptions.PingInterval.

LockOptions is options used in WithLockOpts.