带有Date_Sub的MySQL Query在查询时返回空集，但在包含join时count = 1

I am trying to get a dataset of the last active chat users on my site, however the where clause in the query is "failing" and returning results that have "expired"... I am trying to get a dataset of the last active