UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OloEJqw5iEHAtqAdHNWQpQkS2A4DXCb6Nm3eIZrIN8Q='
WHERE
key_id = 'ce09b12d443a20bccb60c89001d6058737f8a86655c4c057f67ec59a73485e0c'
AND (
token = 'OloEJqw5iEHAtqAdHNWQpQkS2A4DXCb6Nm3eIZrIN8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)