update users set second_to_last_visit = last_visit, last_visit = current_timestamp, n_sessions = n_sessions + 1 where user_id = :user_id delete from sec_session_properties where last_hit < :expires select property_value, secure_p from sec_session_properties where session_id = :id and module = :module and property_name = :name select token from secret_tokens where token_id = :token_id insert into sec_session_properties (session_id, module, property_name, secure_p, last_hit) select :session_id, :module, :name, :secure, :last_hit from dual where not exists (select 1 from sec_session_properties where session_id = :session_id and module = :module and property_name = :name) update sec_session_properties set last_hit = :new_last_hit where session_id = :id and property_name = :name