Database
[{"_id":ObjectId("abc123123456789123456789"),"device_model":"A001","A_status":"VALID","B_status":"VALID"},{"_id":ObjectId("abc223123456789123456789"),"device_model":"A003","A_status":"EXPIRED","B_status":"VALID"},{"_id":ObjectId("abc323123456789123456789"),"device_model":"B001","A_status":"EXPIRED","B_status":"VALID"},{"_id":ObjectId("abc423123456789123456789"),"device_model":"B002","A_status":"VALID","B_status":"EXPIRED"}]
Query
db.collection.find({$or:[{A_status:"VALID",device_model:{$in:["A001","A003"]}},{B_status:"VALID",device_model:{$in:["B001","B002"]}}]})