UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZvZG6npggNNsglMm1nS+LpF4+wzkvGa+olWFmG9ZFf8=' 
WHERE 
  key_id = '1a023d3d6888f773adc383f32562936d0ae079d77126529fabb457f760d4a10d' 
  AND (
    token = 'ZvZG6npggNNsglMm1nS+LpF4+wzkvGa+olWFmG9ZFf8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033