UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PyXPXksmRF4Xqd/2bHmEdWYdgGr9sL13IY5lqiy1qgE='
WHERE
key_id = '9b58e56c8f5c3db42cbb3917577281593d1ae15bb59e7cc3c7a98a723c1c1621'
AND (
token = 'PyXPXksmRF4Xqd/2bHmEdWYdgGr9sL13IY5lqiy1qgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)