UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1aI9HEM4q3y1SDVE0XN3PXUCf7Gk4hUTCmH1hELkLo4='
WHERE
key_id = '38e97cee16f697fea9e87b809e3b395cea064f22fa45859823adc979a9e9b102'
AND (
token = '1aI9HEM4q3y1SDVE0XN3PXUCf7Gk4hUTCmH1hELkLo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)