begin transaction

update sequence_table set next_key = next_key + 1 
 where sequence_name = 'somename'
 
select next_key from sequence_table
 where sequence_name = 'somename'

commit transaction