UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mPXpRZaU2d6FL8LgXjaI8nhV4+PyYatZoV/A/QaKJ14=' 
WHERE 
  key_id = '1730f54545a7ecca16cd82a6dc3d1300447e288e76d3555c2bd2806b7c40733d' 
  AND (
    token = 'mPXpRZaU2d6FL8LgXjaI8nhV4+PyYatZoV/A/QaKJ14=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035