[{"_id":ObjectId("60c3253f19862e6347bc9f4e"),"farm_id":"Gustavo-chainer","first_ts":ISODate("2021-05-18T09:53:00.000Z"),"last_ts":ISODate("2021-05-18T12:53:00.000Z"),"sensor_data":[{"data":76.0,"sensor":"temperature-sensor","start_ts":ISODate("2021-05-18T09:33:00.000Z"),"end_ts":ISODate("2021-05-18T09:53:00.000Z")},{"data":74.0,"sensor":"temperature-sensor","start_ts":ISODate("2021-05-18T12:33:00.000Z"),"end_ts":ISODate("2021-05-18T12:53:00.000Z")}]}]

db.collection.update({sensor_data:{$elemMatch:{start_ts:ISODate("2021-05-18T12:33:00.000Z"),end_ts:ISODate("2021-05-18T12:53:00.000Z")}}},[{$set:{sensor_data:{$filter:{input:"$sensor_data",cond:{$not:{$and:[{$eq:["$$this.start_ts",ISODate("2021-05-18T12:33:00.000Z")]},{$eq:["$$this.end_ts",ISODate("2021-05-18T12:53:00.000Z")]}]}}}}}},{$set:{first_ts:{$min:"$sensor_data.start_ts"},last_ts:{$max:"$sensor_data.end_ts"}}}],{multi:true})