In that case you only need a single guest login page. If a visitor logs in, he is authenticated to the guest user database where you set the expiration on the account when you generated the scratch card.
If you have the same authentication service authenticate also to your SQL database, residents can log in as long as the SQL database allows them access.
The account expiration is done in the authentication source, not in the Web login page.
If you really want two different Web login pages, that can be done, but is is not required and in most cases more difficult for the end-user.
There are no accounts created from a Web login page.
Please try to contact your Aruba partner or Aruba TAC as they can work with you interactively to find out what is needed and help you configure it.