UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zV7JezEWvArWQPCf05PWPUFgDfT90hdPtielHVuEPdQ='
WHERE
key_id = '980668215c073e1e6eba60bd60aacf91dda4e4095d9133c10f106a92dd26e8c3'
AND (
token = 'zV7JezEWvArWQPCf05PWPUFgDfT90hdPtielHVuEPdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)