UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NY5+AB4Z4OucALxpLYvKQTMNlqIXpF3Eqwb9Sr6q9o8='
WHERE
key_id = '57181a0a10b6f26237d9e9df73485375819b93ec30f23a0f1480799cb942cf1a'
AND (
token = 'NY5+AB4Z4OucALxpLYvKQTMNlqIXpF3Eqwb9Sr6q9o8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)