You can get the row with customerId=1 using the 'Get table rows' endpoint & the EQUALS filter. Then, you can use the rowId to update both cells at once by using the 'Update a row' endpoint. HubDB isn't a fully fledged relational database, so it's not possible to make the query you specified above.
To update a table row, you need the internal row ID. You might consider pulling the row you're looking for using the 'Get table rows' endpoint (filtering by CustomerID) and then updating that row once you have the row ID.
.png "HubSpot Alumni"){kind=icon}
