Database
[{"_id":1,"name":"Alex","quantity":10,"lastActivityTime":ISODate("2022-09-01T03:38:29Z"),"lastRefreshTime":ISODate("2022-10-01T20:54:19.618Z"),"checking":[1,2,3],}]
Query
db.collection.update({_id:1},[{"$set":{"quantity":{$cond:{if:{$lt:["$lastActivityTime",ISODate("2022-09-01T03:38:30Z")]},then:{$sum:["$quantity",1]},else:"$quantity"}},"lastActivityTime":"$$NOW","checking":{$filter:{input:"$checking",as:"item",cond:{$ne:["$$item",3]}}}}}])