UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '57IXBvAEqLY/3qZrRg/uqngh2HSlOQVf0t23FubR1zw='
WHERE
key_id = '93a871a32e6e5f4d1dc753f587cb531a6252d5b9f8b357432c29c8a41fe11372'
AND (
token = '57IXBvAEqLY/3qZrRg/uqngh2HSlOQVf0t23FubR1zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)