UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FNxUibg4zdqF3iM5YkuZIVaPbFzV8ihvmURKzV7wGjY='
WHERE
key_id = 'ba5d80be4a9b920087f61dea3eec31dd5e6da735e358e46f1bd1a61900b6c915'
AND (
token = 'FNxUibg4zdqF3iM5YkuZIVaPbFzV8ihvmURKzV7wGjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)