Rules condition if user has certain roles not working at all?
Sorry, ignore my last comment.

You need a condition of "user as role" set to "site:current-user".
Then select the role that is required which is "moderator".
Leave everything else unchanged and save.

You need an action of "add role"
This action defaults to "account" so leave it as is.
Select the role you want to add, and save.