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