UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N4sSDlk4qgIMpcF/0pK5ENNHua8u1j8+Sva8OgBWQZ8='
WHERE
key_id = 'd54eb00bdc4f90c1386e57ee90763cbc3a05e7d629919c805dbfb72a880d230a'
AND (
token = 'N4sSDlk4qgIMpcF/0pK5ENNHua8u1j8+Sva8OgBWQZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)