UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ILT5CcmSMvLwvuZ1oTRK/xTI371eCX0OEZjxXLBpU3w='
WHERE
key_id = '0690276e3ed9f138c776c2d206195fe1b0b96f1e9cbdd41b5c5c7e8f1e25836e'
AND (
token = 'ILT5CcmSMvLwvuZ1oTRK/xTI371eCX0OEZjxXLBpU3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)