Index event_id. If the performance of this read operation its far way important than the write of event_ranks, you can index all the fields in the select of the query (all in this case) making a covering index (an index that covers all the fields in the query). This is would do the trick.
When indexing multiple fields in one index, put the one in the where first and the ones in the select later.