UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gA6LA3jmUx0WzCxbJSDhihVcXAi88Ti6X0MGlVv9Wno='
WHERE
key_id = '1414227782fad0a44dec6a3db8f8610cc71181074a03df1d3d42cf9ae398e78f'
AND (
token = 'gA6LA3jmUx0WzCxbJSDhihVcXAi88Ti6X0MGlVv9Wno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)