BEGIN; DELETE FROM session WHERE member_id=<id>; UPDATE member SET active=FALSE WHERE id=<id>; COMMIT;