mysql> create table meow (id int not null primary key);
Query OK, 0 rows affected (0.07 sec)

mysql> insert into meow (id) values (1);
Query OK, 1 row affected (0.00 sec)

mysql> update meow set id=(id+1) where id = 1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from meow;
+----+
| id |
+----+
|  2 |
+----+
1 row in set (0.00 sec)