UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCC9d6qn43JbqGW1qnmxNwAj8vpUilYJ8szSez26R9I='
WHERE
key_id = '6559291c50faad7490d9241710c0da0a4a36d89294c1a0532eb75ae3d76798cf'
AND (
token = 'SCC9d6qn43JbqGW1qnmxNwAj8vpUilYJ8szSez26R9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)