Reuse prepared statements in hot auth queries

patch by Aleksey Yeschenko; reviewed by Jonathan Ellis for
CASSANDRA-5594