Is this possible and does it sound reasonable?
User logs in.
Add to database user id, session id.
If user logs in again.
Check if user id and session id match database.
if they do not
display a message indicating another session is opened or not successfully closed. provide a link to click that will destroy the old session and create a new one.
once new session is created update database with new session id.
if this is possible how would i delete the old session based on the session id?