UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+9uCCoN7I7tcGwU9vvgNsX7gCZKIBA4jCjGWDqfhIYY=' 
WHERE 
  key_id = 'c4a743533e3a6f85d9f07646dd47e4d7aadd2c4c836af33c92e073f1826212ba' 
  AND (
    token = '+9uCCoN7I7tcGwU9vvgNsX7gCZKIBA4jCjGWDqfhIYY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030