UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fM3Zzu6n4htNAMHTQSBZdnU5mJyJOKGKbmxMLXDM1wA='
WHERE
key_id = '07815130b9dc64534fbe078bf7daca2219f04672707a0ba2c9fbb6d1ab7ffa99'
AND (
token = 'fM3Zzu6n4htNAMHTQSBZdnU5mJyJOKGKbmxMLXDM1wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)