How can I speed up my slow query?
Presumably a pigeon cannot arrive at a station twice in one second?  Then add this:

PRIMARY KEY(pigeon_id, pigeon_station, date_time)


This will improve on ypercube's suggestion, perhaps by a factor of 2.

At that point, probably both of your indexes become useless.  But before that, let's see the other important queries.