UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '97L7aEFFah3kGiTaVQ37rIGfch79R//6apa/0T9thco=' 
WHERE 
  key_id = '70e0813167dba659aece5edf2abdfb60b071f198a8044d54d60ba31149b13d94' 
  AND (
    token = '97L7aEFFah3kGiTaVQ37rIGfch79R//6apa/0T9thco=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023