If I’m right bp always set last_activity meta in gmt ( bp_core_record_activity() in bp-core.php use gmdate ) so the query should compare with that timezone, I tried using UTC_TIMESTAMP() instead of NOW() in the query and it’s working.
If some expert can confirm that this solution is valide not only for my configuration but for everyone I’ll open a ticket.
