UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cDDKe46eQS28X7fV/K9Was5J8jZPhc0QVNRj+4oCGB4='
WHERE
key_id = 'b538ac359522272bc5a637cf9411ea0a5c34b0a207f0e73a701331922e19d5d9'
AND (
token = 'cDDKe46eQS28X7fV/K9Was5J8jZPhc0QVNRj+4oCGB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)