UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OTuQ/25khOywjPlsInNTCBpaB8xflwQCmAIrzyNvn0o='
WHERE
key_id = 'd2f4e6445505e1f30df4e3f9736012c1d11fa2f940b805c0ad5db95a8062edb0'
AND (
token = 'OTuQ/25khOywjPlsInNTCBpaB8xflwQCmAIrzyNvn0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)