UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e6yHlGoJU39DnVZQ4KzgkHuseH2kTYa0YdFUhzTaytk='
WHERE
key_id = '049d60a7246a64559cd14953f3607428c3c4b2bda712947cd686c64984efd806'
AND (
token = 'e6yHlGoJU39DnVZQ4KzgkHuseH2kTYa0YdFUhzTaytk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)