It’s worth pointing out that if you had to do this to several records you can use streaming syntax.

SELECT ONE FROM order_detail AS item where <SOME CLAUSE>{
var amount = item.amount + 100
UPDATE order_detail(amount:amount) where id == item.id
}