UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zaD/PJqP0RDAzApLxFUONf4tIGeD2zTldgoOB3rCd6U='
WHERE
key_id = '7a6ee6f17fdcd925286c612d875369a315786e2c69a91a112facea2ea415958a'
AND (
token = 'zaD/PJqP0RDAzApLxFUONf4tIGeD2zTldgoOB3rCd6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)