UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D3qkfh2xMUMxKp7dr4mEmmVApXGucOazFQepoRb3y78='
WHERE
key_id = '9d3bd5ae2389dd0d59f73ad567bbd7f2981fb5392c455bb385b202e0d6b08720'
AND (
token = 'D3qkfh2xMUMxKp7dr4mEmmVApXGucOazFQepoRb3y78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)