as[netdb roles change by tsql

SQL 2005

Assumptions
1) I only allow one role per user in SQL server 2005
2) the aspnetdb tables are stored within my project DB

I have a stuation like this
Roles
Service1
Service2
Trial
Expired

Roles named Service1, Service2 and Trial all expire.
So I have a table like this

table: DIM_myUsers
GUID             ExpireDate  
afaf-fddf        05/30/2010    
fdfdf-fdfdf      05/20/2010

I need to run a daily job (TSQL) that will check the current date against the 'DIM_myUsers' table to see if today is older than the expire date, and it is then update in aspnetdb the role from 'Service1' or (whatever) to 'Expired'

But only do this for roles that are not expired so I guess
Roles <> & ...