UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1OPQXS4n/ZdvCjQzNF9w1rcJmZYTuW/0BAzZaOLnHvk='
WHERE
key_id = 'b20ba5789ee8d4caa5d0d658fecd0ad09ed3fff06951b33add983a036522527a'
AND (
token = '1OPQXS4n/ZdvCjQzNF9w1rcJmZYTuW/0BAzZaOLnHvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)