UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kKj7L4Tz6E615LkB762rFOv0fe1cjPU9E42If4Ajzlk=' 
WHERE 
  key_id = '500d8b280cd58e9e545a06ea6e11d5136a470c909e17b098590a5ebc887c9d1a' 
  AND (
    token = 'kKj7L4Tz6E615LkB762rFOv0fe1cjPU9E42If4Ajzlk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028