UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lAlRg0+GmiLQuoJmOdrub4SavJ2bdb8gS8W1sUuMHs4='
WHERE
key_id = '97934c05714c39d4036add0126c71df487aabeebbce43508649cb6ce3246a81e'
AND (
token = 'lAlRg0+GmiLQuoJmOdrub4SavJ2bdb8gS8W1sUuMHs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)