By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE MyTable(Flag INT, ID INT, OrderID INT)
INSERT INTO MyTable(ID, OrderId, Flag)
VALUES (5, 10, 0),(5, 11,0);
UPDATE MyTable
SET Flag = 1
WHERE (ID, ORDERID) IN ( SELECT ID, ORDERID
FROM MyTable
WHERE ID = 5
ORDER BY OrderID DESC LIMIT 1);
SELECT * FROM MyTable;
| Flag | ID | OrderID |
|---|---|---|
| 0 | 5 | 10 |
| 1 | 5 | 11 |