update address set streetno=34, ... where custno=456 and streetno=56 ...

Example 1: Update statement with conflict detection predicates.