T1: (в ней только одна запись)
`lastSequence` bigint(20) unsigned NOT NULL
`ts_update`    timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
`oState`       int(1) unsigned NOT NULL DEFAULT '0'

T2: (в неё записи добавляются, их много)
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT
`seq` bigint(20) unsigned DEFAULT NULL [KEY `IND_OP_BY_SEQ` (`seq`)]
`ts_filed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
`op_id` bigint(20) unsigned NOT NULL

select T2.op_id, T2.seq, T1.oState
  from T2, T1
  where T2.seq = T1.lastSequence + 1;