UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Wq9oolQXze9bencIZMolj5eMZJHw4isQM2Mm20Pht4='
WHERE
key_id = '9ab686f77e42e8450a3423de2123b3eb2bc3cba012947aa6644cf4c69ac6ca1d'
AND (
token = '5Wq9oolQXze9bencIZMolj5eMZJHw4isQM2Mm20Pht4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)