UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Qfly9hZ8SnHEc3PEGXCAsD+W4qc8e8fxjIsMbmQRgM='
WHERE
key_id = '4f320edb4a955220566d03e1c1864a03221843fd2693a336dc49417d800d9841'
AND (
token = '3Qfly9hZ8SnHEc3PEGXCAsD+W4qc8e8fxjIsMbmQRgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)