[{"_id":ObjectId("626f942bb092f78afd9dad9d"),"item_id":"external _id222","metadata":{"item_name":"abc","quantity":123,"state":null},}]

db.collection.update({"metadata.quantity":123},{"$inc":{"metadata.quantity":1},"$set":{"metadata.state":"SOLD"}},{"multi":false,"upsert":false})