UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ZxPSWXj7UNmtkKEX34ciQiazcsiFeG0hlxAbh4UbCw='
WHERE
key_id = '6acd1f32729fc445a0a22632b2c93aa498aee0297a1753237013e291c07af1a1'
AND (
token = '8ZxPSWXj7UNmtkKEX34ciQiazcsiFeG0hlxAbh4UbCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)