UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0PXlGVB553i8VJC33lXlxr7iHrRRX1Dx2dAK0QgJalo='
WHERE
key_id = '4ee2c2c47e9693ba2ec2c5161b3bdf520a2421ad55f462b95ca0b246ce56dfe9'
AND (
token = '0PXlGVB553i8VJC33lXlxr7iHrRRX1Dx2dAK0QgJalo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)