Database
[{"_id":"62ac8190ddb08e6ee5f2c7dd","status":"NEW","vendor":"62ac8171ddb08e6ee5f2c7ca","productsInOrder":[{"product":"62ac8176ddb08e6ee5f2c7cd","amount":1},{"product":"62ac8181ddb08e6ee5f2c7d0","amount":1}],"createdAt":"2022-06-17T13:28:48.815Z","updatedAt":"2022-06-17T13:39:44.073Z","orderNumber":82,"__v":2}]
Query
db.collection.update({status:"NEW",vendor:"62ac8171ddb08e6ee5f2c7ca",productsInOrder:{$elemMatch:{product:"62ac8181ddb08e6ee5f2c7d0",amount:{$lte:3}}}},{$inc:{"productsInOrder.$.amount":1}})