UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'y5g6ZRLK/xsPCygf7K5DcE7r31bP7L7huZgFR0zMAFM=' 
WHERE 
  key_id = '3fc2040d4cf6142a216d0fbd6bf24c74808c2d772ee08764f6b7df57ae502ad2' 
  AND (
    token = 'y5g6ZRLK/xsPCygf7K5DcE7r31bP7L7huZgFR0zMAFM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034