UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rUaF8WGznD3UJv+GtZh+5fRjSohwzUWvZWr9yGABiI='
WHERE
key_id = '70b96c1826a9d42cbb56e14954a7ca93cf6a893d58e7df2ebda69ffe6eb2c8e9'
AND (
token = '8rUaF8WGznD3UJv+GtZh+5fRjSohwzUWvZWr9yGABiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)