Use memory store cache for the Gitlab::Auth

What does this MR do?

This avoids leaking information into Rails.cache that could influence other specs.

Closes #38084 (closed)