expected_lock_name will have a $WITH_ADVISORY_LOCK_PREFIX prefix.