I am unclear exactly what you want to do with modified_date. Can you write pseudo code perhaps?
It sounds like you are wanting to union all the results of the query you gave, with the results of a similar query where modified_date >= '2021-03-01 08:16:13.589' and created_at < '2021-03-01 08:16:13.589'.
However, if modified date is not null, and is set to the created_date by default, then there seems no reason to check the created_date except if partition pruning at plan time is very important.
Are you experiencing an actual performance problem, are you unsure how to write the query for the data you want, or is this premature optimization?
