UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WJN+aPflRSKuv80zN1iV2TzfOCuAoxhOV1MHtznhoPs='
WHERE
key_id = 'f8f4803e1918275791dbe08d3ce3f739711ddba9f8974119cca273475f326a56'
AND (
token = 'WJN+aPflRSKuv80zN1iV2TzfOCuAoxhOV1MHtznhoPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)