UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ieW9s9WwYYs2Jm70vqOLkIRTfpguOEMIDdYWBddQWY='
WHERE
key_id = 'f9f6c49e9bff7cc187640e1fd80db975371f88274a6d2c5accfc3f5ce7c1db70'
AND (
token = '8ieW9s9WwYYs2Jm70vqOLkIRTfpguOEMIDdYWBddQWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)