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

Query time 0.00029