delete from sec_session_properties where :current_time - last_hit > :property_life select password, salt from users where user_id = :user_id update users set password = :new_password, salt = :salt where user_id = :user_id select property_value, secure_p from sec_session_properties where session_id = :id and module = :module and property_name = :name delete from sec_session_properties where session_id = :session_id and module = :module and property_name = :name insert into sec_session_properties (session_id, module, property_name, property_value, secure_p, last_hit) values ( :session_id, :module, :name, :value, :secure, :last_hit ) select token from secret_tokens where token_id = :token_id