UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sQwAAqUmasdLMyNLoKXxNxTSRAGIDuPdUeLgCJp7xUk='
WHERE
key_id = '3620ad5bded508be59e0140e2213d0833fa351d3ad138c0258ee88dd52855bc5'
AND (
token = 'sQwAAqUmasdLMyNLoKXxNxTSRAGIDuPdUeLgCJp7xUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)