UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCkI1w5s3yTbri20Aj9C2xyL/HRb1st2cRSSk+NRazo='
WHERE
key_id = 'f0419a77db84ef78d4cf5e17431cc29c7fe3af26905b637e87a11d72f114f5a5'
AND (
token = 'pCkI1w5s3yTbri20Aj9C2xyL/HRb1st2cRSSk+NRazo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)