How to select a row for update values, Using CTEs or suitable method

As you need a conditional update statement, i am assuming that you have only one row whose claim_id is 120301 and ORD=1.

UPDATE claim_data SET amount = 12345 WHERE claim_id = 120301 and Ord = 1

---

Regards, RSingh