UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xTVaNDTHa5S1EGGNDsSQTfvaPMMqo2C0Na4RP7UX5gU='
WHERE
key_id = 'b63829b81a7385a96c4bb23d22c16068afc0ae8f0bf71c5c04226aa8c586f649'
AND (
token = 'xTVaNDTHa5S1EGGNDsSQTfvaPMMqo2C0Na4RP7UX5gU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)