UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LWR/Gwil7pDv8RCkqB1mP8dYe1nVd96f6ElTO3FS0m4='
WHERE
key_id = 'd9fe4165dd504258b2ac0443997d259b0abd8de48d13faf7e8e1ea8b15fe52a4'
AND (
token = 'LWR/Gwil7pDv8RCkqB1mP8dYe1nVd96f6ElTO3FS0m4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)